/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50615
 Source Host           : localhost
 Source Database       : hdjob

 Target Server Type    : MySQL
 Target Server Version : 50615
 File Encoding         : utf-8

 Date: 01/24/2014 09:40:12 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `hd_job_positioncate`
-- ----------------------------
DROP TABLE IF EXISTS `hd_job_positioncate`;
CREATE TABLE `hd_job_positioncate` (
  `posid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `posname` varchar(45) NOT NULL DEFAULT '' COMMENT '行业类别名称',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
  PRIMARY KEY (`posid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='职位类别';

-- ----------------------------
--  Records of `hd_job_positioncate`
-- ----------------------------
BEGIN;
INSERT INTO `hd_job_positioncate` VALUES ('1', 'php程序员', '0'), ('2', '前端程序员', '0'), ('3', 'php初级程序员', '1'), ('4', 'php中级程序员', '1'), ('5', 'php高级程序员', '1'), ('6', '前端初级程序员', '2'), ('7', '前端中级程序员', '2'), ('8', '前端高级程序员', '2');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
